home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
veventspart3.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
2KB
|
46 lines
/*
This is one of the constituent views of vallevents... collecting all events together.
*/
create or replace view veventsPart3 as
select DET_SEQ_NUM, FAREBOX_GLID ,CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm,
rpad('(18) Fare Entry: ID=' || to_char(fare_id, '99') || ', Amt=' || to_char(0.01* amount, '99.99') || ', Autd=' || to_char(auto_dump, '9') || ', Lo=' || to_char(low_fare, '9') || ', Hi=' || to_char(high_fare, '9'), 200) event
from fareentr
union
select DET_SEQ_NUM ,FAREBOX_GLID, CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(19) FB Config' event
from fbconfig
union
select DET_SEQ_NUM ,FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm,
'(20) FB Error: ' || substr(err_string, 1, 200) event
from fberror
union
select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(21) FB Pwr Fail' event
from fbpwrfal
union
select DET_SEQ_NUM ,FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, FARESET_ID , ' ' setclr, 0 alarm, '(22) FareSet Chg' event
from fschng
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(23) Invalid Secur - Command: ' || ocucmnd.descr event
from invalsec, ocucmnd where invalsec.command_id = ocucmnd.id
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr,0 alarm,'(24) JCDoorClose' event
from jcdoorc
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,' ' setclr, 0 alarm,'(25) JCDoorOpen' event
from jcdooro
union
select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(26) Probe Fail' event
from probefail
union
select DET_SEQ_NUM, FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(27) Probe Succ' event
from probesucc;